/*
 Navicat Premium Data Transfer

 Source Server         : 个人_阿里云_ESC
 Source Server Type    : MySQL
 Source Server Version : 50736
 Source Host           : 47.112.179.239:3306
 Source Schema         : sali-bushu-test

 Target Server Type    : MySQL
 Target Server Version : 50736
 File Encoding         : 65001

 Date: 14/05/2022 11:01:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `nickname` varchar(100) DEFAULT NULL COMMENT '用户昵称',
  `password` varchar(60) DEFAULT NULL COMMENT '用户密码',
  `telphone` varchar(20) DEFAULT NULL COMMENT '用户手机(用于登录)',
  `email` varchar(200) DEFAULT NULL COMMENT '用户邮箱',
  `avatar` varchar(400) DEFAULT NULL COMMENT '用户头像的地址',
  `sign` varchar(100) DEFAULT NULL COMMENT '用户签名',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `active` int(1) DEFAULT NULL COMMENT '激活状态(0->未激活，1->激活)',
  `role` varchar(10) DEFAULT NULL COMMENT 'admin是超级管理员，normal是普通用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `nickname`, `password`, `telphone`, `email`, `avatar`, `sign`, `create_time`, `update_time`, `active`, `role`) VALUES (1, 'sali', 'f34467a505c661fc34098ed481b608e5', '18705157099', 'salieri97@163.com', 'touxianglianjie', 'Hello', '2021-11-21 19:15:06', '2021-11-21 19:15:10', 1, 'admin');
INSERT INTO `sys_user` (`id`, `nickname`, `password`, `telphone`, `email`, `avatar`, `sign`, `create_time`, `update_time`, `active`, `role`) VALUES (2, '小赵', '1123', '15640021375', 'elisa00@163.com', 'touxiang2', '1', '2021-11-22 20:17:23', '2021-11-11 20:17:28', 1, 'user');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
